﻿18.4.2013 16:07:34
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 16:07:34
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 16:07:34', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 16:07:34
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 16:07:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 16:07:47
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 16:07:49
UPDATE Login SET 
logout = to_date('18.4.2013 16:07:49', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 342 

18.4.2013 16:08:05
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 16:08:05
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 16:08:05', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 16:08:05
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 16:08:12
UPDATE Login SET 
logout = to_date('18.4.2013 16:08:12', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 344 

18.4.2013 19:27:43
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 19:27:43
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 19:27:43', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 19:27:43
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 19:28:09
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 19:28:13
select * from role order by name

18.4.2013 19:28:14
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 19:28:14
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 19:28:14
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 19:28:14
select * from role order by name

18.4.2013 19:28:32
select * from role order by name

18.4.2013 19:28:32
select * from role order by name

18.4.2013 19:28:32
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 19:28:33
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 19:28:33
select * from company order by name

18.4.2013 19:28:35
select * from role order by name

18.4.2013 19:28:35
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 19:28:37
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 19:28:37
select * from company order by name

18.4.2013 19:28:38
select * from role order by name

18.4.2013 19:28:42
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 19:28:42
select * from company order by name

18.4.2013 19:28:43
select * from role order by name

18.4.2013 19:28:46
select * from role order by name

18.4.2013 19:28:53
UPDATE Login SET 
logout = to_date('18.4.2013 19:28:53', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 346 

18.4.2013 20:05:22
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 20:05:22
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 20:05:22', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 20:05:22
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

